package com.wn.pay.mapper;

import com.wn.pay.entity.BorrowerPayPlan;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 * 借款人还款计划 Mapper 接口
 * </p>
 *
 * @author yellow docker
 * @since 2023-08-07
 */
public interface BorrowerPayPlanMapper extends BaseMapper<BorrowerPayPlan> {

    @Select("SELECT * FROM borrower_pay_plan WHERE DATE_FORMAT(SHOULD_PAY_DATE,'%Y-%m-%d') = #{date} AND PAY_STATUS = '0'")
    List<BorrowerPayPlan> findPayPlanByDate(String date);

}
